DECLARE
   acct_doc   XMLTYPE
      := xmltype ('<?xml version="1.0" encoding="utf-16"?>
<USERDATA>
    <USERID>cismeta</USERID>
    <PASSWORD>tmeta</PASSWORD>
    <PORT>1521</PORT>
</USERDATA>');
BEGIN
   INSERT INTO xml_input1 (userid, password,port)
              SELECT *
                FROM XMLTABLE (
                        '/USERDATA'
                        PASSING acct_doc
                        COLUMNS USERID VARCHAR2(30) PATH 'USERID',
                                PASSWORD VARCHAR2(30) PATH 'PASSWORD',
                                PORT NUMBER PATH 'PORT');
    commit;
END;
/

select * from xml_input1;